/*
 * Copyright (C) 2008 Search Solution Corporation. All rights reserved by Search Solution. 
 *
 * Redistribution and use in source and binary forms, with or without modification, 
 * are permitted provided that the following conditions are met: 
 *
 * - Redistributions of source code must retain the above copyright notice, 
 *   this list of conditions and the following disclaimer. 
 *
 * - Redistributions in binary form must reproduce the above copyright notice, 
 *   this list of conditions and the following disclaimer in the documentation 
 *   and/or other materials provided with the distribution. 
 *
 * - Neither the name of the <ORGANIZATION> nor the names of its contributors 
 *   may be used to endorse or promote products derived from this software without 
 *   specific prior written permission. 
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND 
 * ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED 
 * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. 
 * IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, 
 * INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, 
 * BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, 
 * OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, 
 * WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) 
 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY 
 * OF SUCH DAMAGE. 
 *
 */

package cubrid.jdbc.driver;

import java.sql.*;
import java.util.Hashtable;
import javax.naming.*;

import cubrid.jdbc.driver.CUBRIDException;
import cubrid.jdbc.driver.CUBRIDJDBCErrorCode;

abstract class CUBRIDConnectionPoolManager
{
  private static Hashtable connectionPooltable;
  private static Hashtable poolDataSourceTable;

  static
  {
    connectionPooltable = new Hashtable();
    poolDataSourceTable = new Hashtable();
  }

  static Connection getConnection(CUBRIDConnectionPoolDataSource pds,
      String user, String passwd) throws SQLException
  {
    CUBRIDConnectionEventListener cp;

    String key = pds.getDataSourceID(user);

    synchronized (connectionPooltable)
    {
      cp = (CUBRIDConnectionEventListener) connectionPooltable.get(key);

      if (cp == null)
      {
        cp = addConnectionPool(key, pds);
      }
    }

    return (cp.getConnection(user, passwd));
  }

  static CUBRIDConnectionPoolDataSource getConnectionPoolDataSource(
      String dsName) throws SQLException
  {
    CUBRIDConnectionPoolDataSource cpds;

    synchronized (poolDataSourceTable)
    {
      cpds = (CUBRIDConnectionPoolDataSource) poolDataSourceTable.get(dsName);

      if (cpds == null)
      {
        try
        {
          Context ctx = new InitialContext();
          cpds = (CUBRIDConnectionPoolDataSource) ctx.lookup(dsName);
        }
        catch (NamingException e)
        {
          throw new CUBRIDException(CUBRIDJDBCErrorCode.unknown, e.toString());
        }

        poolDataSourceTable.put(dsName, cpds);
      }
    }

    return cpds;
  }

  static private CUBRIDConnectionEventListener addConnectionPool(String key,
      CUBRIDConnectionPoolDataSource pds)
  {
    CUBRIDConnectionEventListener cp = new CUBRIDConnectionEventListener(pds);
    connectionPooltable.put(key, cp);
    return cp;
  }
}
